﻿ using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WpfApp1.mysqlunit
{
    class sqlyuju
    {
    }
}


//CREATE DATABASE zupan;

//CREATE TABLE `package` (
//  `pcode` varchar(45) DEFAULT NULL COMMENT '包条码',
//  `batch` varchar(45) DEFAULT NULL COMMENT '节号',
//  `onum` varchar(45) DEFAULT NULL COMMENT '单号',
//  `pid` int (10) unsigned NOT NULL COMMENT '包id',
//  `pallet_id` int (10) unsigned DEFAULT NULL COMMENT '车间盘位id',
//  `deliver_time` int (10) unsigned DEFAULT NULL COMMENT '发货时间',
//  `warehousing_time` int (10) unsigned DEFAULT NULL COMMENT '入仓时间',
//  `zp_ctime` int (10) unsigned DEFAULT NULL COMMENT '组盘时间',
//  `pcpid` int (10) unsigned DEFAULT NULL COMMENT '盘周期id',
//  `pallet_num` varchar(45) DEFAULT NULL COMMENT '盘号',
//  PRIMARY KEY(`pid`)
//) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = '包数据';


//CREATE TABLE `pallet` (
//  `id` int (10) unsigned NOT NULL AUTO_INCREMENT,
//  `buffer` varchar(45) COMMENT '盘缓冲位置',
//  `panname` varchar(45) DEFAULT NULL COMMENT '盘号',
//  `onum` varchar(45) DEFAULT NULL COMMENT '单号',
//  PRIMARY KEY(`id`)
//) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = '盘位数据';


//CREATE TABLE `user` (
//  `id` int (10) unsigned NOT NULL AUTO_INCREMENT,
//  `username` varchar(45) DEFAULT NULL COMMENT 'username',
//  `password` varchar(45) DEFAULT NULL COMMENT 'password',
//  `session_name` varchar(255) DEFAULT NULL COMMENT 'session_name',
//  `token` varchar(255) DEFAULT NULL COMMENT 'token',
//  `cookie` varchar(255) DEFAULT NULL COMMENT 'cookie',
//  PRIMARY KEY(`id`)
//) ENGINE = InnoDB AUTO_INCREMENT = 2 DEFAULT CHARSET = utf8 COMMENT='账号信息';

//CREATE TABLE IF NOT EXISTS `scan_record_log` (
//      `id` INT UNSIGNED AUTO_INCREMENT,
//      `scan_string` varchar(45) DEFAULT NULL COMMENT '扫描的条码',
//      `ctime` varchar(45) DEFAULT NULL COMMENT '创建时间',
//      `miaoshu` varchar(255) DEFAULT NULL COMMENT '描述',
//      PRIMARY KEY( `id` )
//      )ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = '扫描记录';

//CREATE TABLE `bufferap` (
//  `bufferap` varchar(45) COMMENT '缓冲仓位号'
//) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = 'AP托盘的缓冲仓位号';

//将数据记录中ctime类型字符串改成int，增加查询速度
//alter table scan_record_log drop  column ctime;
//alter table scan_record_log add column ctime int (10) unsigned COMMENT '创建时间';



